Practice Test

Q1) A formula may start with any symbol. Show Answer

Q2) Worksheets can be linked with each other only if they are in the same workbook. Show Answer

Q3) When a worksheet in one workbook is linked with another worksheet in the same workbook, then the workbook name does not appear in the linked formula. Show Answer

Q4) A template has the file name extension .XLTX Show Answer

Q5) Named ranges use absolute references. Show Answer

Q6) Worksheets created with a template can have same formatting but cannot use predefined formulae. Show Answer

Q7) A template is saved in the templates folder. Show Answer

Q8) An external reference is a reference to a cell in another Excel workbook. Show Answer

Q9) A dependent workbook contains a link to another workbook. Show Answer

Q10) There are no drawbacks to linking workbooks. Show Answer

Q11) The general syntax for an external reference formula is :
= [ WorkbookName]SheetName!CellAddress
Show Answer

Q12) The Paste Special command can be used to create external reference formulas. Show Answer

Q13) If there is a change in the source workbook, the dependent workbook is not automatically updated. Show Answer

Q14) Logical formula can contain only the +, -, * and / operators. Show Answer

Q15) A logical formula can have only two possible outputs: Show Answer

Q16) The logical function AND returns the value TRUE only if all the conditions in it are Show Answer

Q17) The logical function OR returns the value FALSE if any one condition is Show Answer

Q18) The logical function NOT returns the value FALSE if its argument is FALSE. Show Answer

Q19) The advantage of creating name range is that it makes the formula more readable. Show Answer

Q20) Once a named range is created, it can be edited or deleted. Show Answer

Q21) When you are typing a formula in a cell. The first thing that must be entered is: Show Answer

Q22) Which of these is the correct way of referencing a cell A1 on worksheet named Admission2009 in the same workbook : Show Answer

Q23) When referring to a cell in another worksheet (same workbook), the sheet reference is always ________, while the cell reference may be _______. Show Answer

Q24) The result of a logical formula is Show Answer

Q25) Excel templates have the file name extension Show Answer

Q26) A template worksheet contains the following information: Show Answer

Q27) Consider the formula = [MONTHLYINC.xlsx ]MONTHINC!$F$5. In this formula, Show Answer

Q28) If sell A3 contains 10 and cell A4 contains 15, then what is the return value of the formula = AND(A3 > 9, A4 < 20)? Show Answer

Q29) If cell If sell A3 contains 10 and cell A4 contains 15, then what is the return value of the formula = OR (A3 > 9, A4 < 5)? Show Answer

Q30) If cell A3 is named PassMks and contains the value 40, cell A4 contains the number 76, what is the value of the expression = IF (A4 >= PassMks, “Pass,” “Fail”)? Show Answer

Q31) A selection consisting of two or more cells on a worksheet is called Show Answer

Q32) Which of the following is a valid external reference formula? Show Answer